﻿CREATE TABLE [acms].[FolderVersions]
(
[Id] [int] NOT NULL IDENTITY(1, 1),
[FolderId] [int] NOT NULL,
[ParentId] [int] NULL,
[Name] [varchar] (50) NOT NULL,
[StatusId] [int] NOT NULL,
[Path] [varchar] (255) NOT NULL CONSTRAINT [DF_FolderVersion_Version] DEFAULT ((0)),
[Sequence] [int] NOT NULL DEFAULT(0),
[ConcurrentId] [int] NOT NULL CONSTRAINT [DF_FolderVersion_ConcurrentId] DEFAULT ((0)),
[Created] [datetime] NOT NULL CONSTRAINT [DF_FolderVersion_Created] DEFAULT (getdate()),
[LastUpdated] [datetime] NOT NULL CONSTRAINT [DF_FolderVersion_LastUpdated] DEFAULT (getdate())
) ON [PRIMARY]


